UPDATE c1_user t INNER JOIN t_user u ON (t.USER_ID=u.ID)
SET t.USER_CODE= u.USER_CODE,
t.ID_CARD_NO= u.ID_CODE,
t.NAME= u.USER_NAME,
t.PASSWORD_= u.PASSWORD,
t.DEPARTMENT_CODE= REPLACE(u.DEPT_CODE, 'root','') ,
t.TELEPHONE= u.PHONE_NUM,
t.BIRTHDAY= u.BIRTHDAY,
t.SEX_CODE= u.SEX,
t.LOCUS= u.ADDRESS